# sqlserver_crud.py
from .database import sqlserver_db

async def get_sqlserver_orders():
    query = "SELECT * FROM orders"
    return await sqlserver_db.fetch_all(query)

async def create_sqlserver_order(product: str):
    query = """
    INSERT INTO orders (product, order_time)
    VALUES (:product, CURRENT_TIMESTAMP)
    """
    return await sqlserver_db.execute(query, values={"product": product})